DataBases

release	jdbc:oracle:thin:@localhost:1521:wpsdb
community jdbc:oracle:thin:@localhost:1521:wpsdb
customization jdbc:oracle:thin:@localhost:1521:wpsdb
wmmdb	jdbc:oracle:thin:@localhost:1521:wpsdb
jcrdb	jdbc:oracle:thin:@localhost:1521:wpsdb
fdbkdb	jdbc:oracle:thin:@localhost:1521:wpsdb
lmdb	jdbc:oracle:thin:@localhost:1521:wpsdb

Users/Passwords
SYSTEM/cyber2003
jcrdb/releaseusr 	releaseusr 		
jcrdb/communityusr 	communityusr 
jcrdb/customizationusr 	customizationusr 
jcrdb/icmadmin		icmadmin
jcrdb/wmmdbusr		wmmdbusr
jcrdb/feedback		feedback
jcrdb/lmdbusr		lmdbusr

SQL> create user releaseusr identified by releaseusr default tablespace users temporary tablespace temp;
SQL> create user communityusr identified by communityusr default tablespace users temporary tablespace temp;
SQL> create user customizationusr identified by customizationusr default tablespace users temporary tablespace temp;
SQL> create user wmmdbusr identified by wmmdbusr default tablespace users temporary tablespace temp;
SQL> create user feedback identified by feedback default tablespace users temporary tablespace temp;
SQL> create user lmdbusr identified by lmdbusr default tablespace users temporary tablespace temp;

SQL> grant select on dba_pending_transactions to releaseusr;
SQL> grant connect, resource to releaseusr;
SQL> grant select on dba_pending_transactions to communityusr;
SQL> grant connect, resource to communityusr;
SQL> grant select on dba_pending_transactions to customizationusr;
SQL> grant connect, resource to customizationusr;
SQL> grant select on dba_pending_transactions to wmmdbusr;
SQL> grant connect, resource to wmmdbusr;

SQL> grant select on dba_pending_transactions to feedback;
SQL> grant connect, resource, create session to feedback;

SQL> grant select on dba_pending_transactions to lmdbusr;
SQL> grant connect, resource, create session to lmdbusr;
SQL> grant insert any table to lmdbusr;


SQL> create user icmadmin identified by icmadmin default tablespace users temporary tablespace temp;

SQL> GRANT create session, alter session, create table, 
create view, create procedure, create trigger, create library, 
create tablespace, alter tablespace, drop tablespace, 
execute any procedure, unlimited tablespace, create public synonym, 
drop public synonym, create sequence to icmadmin;

SQL> grant select on dba_pending_transactions to icmadmin;
SQL> grant connect, resource to icmadmin;
SQL> grant insert any table to icmadmin;